package com.uspacex.calculate.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.LinkedHashMap;
import java.util.List;

@Mapper
public interface AnalysisMapper {

    @Select("SELECT date_info FROM db_enterprise_info.balance_sheet")
    List<LinkedHashMap<String, Object>> dateInfo();

    @Select("SELECT * FROM db_enterprise_info.balance_sheet")
    List<LinkedHashMap<String, Object>> zichanfuzhai();

    @Select("SELECT * FROM db_enterprise_info.profit_statement")
    List<LinkedHashMap<String, Object>> lirun();

    @Select("SELECT * FROM db_enterprise_info.cash_flow_statement")
    List<LinkedHashMap<String, Object>> xianjinliuliang();

    @Select("SELECT * FROM db_enterprise_info.balance_sheet WHERE date_info =#{date}")
    List<LinkedHashMap<String, Object>> zichanfuzhaiByDate(@Param("date") String date);

    @Select("SELECT * FROM db_enterprise_info.profit_statement WHERE date_info =#{date}")
    List<LinkedHashMap<String, Object>> lirunByDate(@Param("date") String date);

    @Select("SELECT * FROM db_enterprise_info.cash_flow_statement WHERE date_info =#{date}")
    List<LinkedHashMap<String, Object>> xianjinliuliangByDate(@Param("date") String date);

}
